<HTML>
<BODY BGCOLOR="white">
<PRE>
<FONT color="green">001</FONT>    package org.hackystat.sensorbase.db.derby;<a name="line.1"></a>
<FONT color="green">002</FONT>    <a name="line.2"></a>
<FONT color="green">003</FONT>    import static org.junit.Assert.assertEquals;<a name="line.3"></a>
<FONT color="green">004</FONT>    <a name="line.4"></a>
<FONT color="green">005</FONT>    import java.util.ArrayList;<a name="line.5"></a>
<FONT color="green">006</FONT>    import java.util.List;<a name="line.6"></a>
<FONT color="green">007</FONT>    import org.junit.Test;<a name="line.7"></a>
<FONT color="green">008</FONT>    <a name="line.8"></a>
<FONT color="green">009</FONT>    <a name="line.9"></a>
<FONT color="green">010</FONT>    /**<a name="line.10"></a>
<FONT color="green">011</FONT>     * Tests the constructUriPattern method, which does a non-trivial transformation of the UriPatterns<a name="line.11"></a>
<FONT color="green">012</FONT>     * into LIKE clauses.  This also helps document the behavior of the transformation by illustrating<a name="line.12"></a>
<FONT color="green">013</FONT>     * canonical input-output pairs.<a name="line.13"></a>
<FONT color="green">014</FONT>     *  <a name="line.14"></a>
<FONT color="green">015</FONT>     * @author Philip Johnson<a name="line.15"></a>
<FONT color="green">016</FONT>     */<a name="line.16"></a>
<FONT color="green">017</FONT>    public class TestConstructLikeClauses {<a name="line.17"></a>
<FONT color="green">018</FONT>    <a name="line.18"></a>
<FONT color="green">019</FONT>      /**<a name="line.19"></a>
<FONT color="green">020</FONT>       * Tests that the LIKE clauses are constructed correctly.<a name="line.20"></a>
<FONT color="green">021</FONT>       */ <a name="line.21"></a>
<FONT color="green">022</FONT>      @Test<a name="line.22"></a>
<FONT color="green">023</FONT>      public void testUriPatterns() {<a name="line.23"></a>
<FONT color="green">024</FONT>        //Test special cases.<a name="line.24"></a>
<FONT color="green">025</FONT>        assertEquals("Test null", "", DerbyImplementation.constructLikeClauses(null));<a name="line.25"></a>
<FONT color="green">026</FONT>        List&lt;String&gt; patts = new ArrayList&lt;String&gt;();<a name="line.26"></a>
<FONT color="green">027</FONT>        patts.add("*");<a name="line.27"></a>
<FONT color="green">028</FONT>        assertEquals("Test *", "", DerbyImplementation.constructLikeClauses(patts));<a name="line.28"></a>
<FONT color="green">029</FONT>        patts.set(0, "**");<a name="line.29"></a>
<FONT color="green">030</FONT>        assertEquals("Test **", "", DerbyImplementation.constructLikeClauses(patts));<a name="line.30"></a>
<FONT color="green">031</FONT>        // Note that we need to escape occurrences of '\' character below.<a name="line.31"></a>
<FONT color="green">032</FONT>        patts.set(0, "*.java");<a name="line.32"></a>
<FONT color="green">033</FONT>        assertEquals("Test single pattern, no path separator", <a name="line.33"></a>
<FONT color="green">034</FONT>            " AND ((RESOURCE LIKE '%.java' ESCAPE '`') )", <a name="line.34"></a>
<FONT color="green">035</FONT>            DerbyImplementation.constructLikeClauses(patts));<a name="line.35"></a>
<FONT color="green">036</FONT>    <a name="line.36"></a>
<FONT color="green">037</FONT>        // Same return value, whether */foo/* or *\foo\*.<a name="line.37"></a>
<FONT color="green">038</FONT>        String singleSlash = <a name="line.38"></a>
<FONT color="green">039</FONT>          " AND ((RESOURCE LIKE '%/foo/%' ESCAPE '`') OR (RESOURCE LIKE '%\\foo\\%' ESCAPE '`') )";<a name="line.39"></a>
<FONT color="green">040</FONT>        patts.set(0, "*/foo/*");<a name="line.40"></a>
<FONT color="green">041</FONT>        assertEquals("Test single pattern, forward slash", singleSlash, <a name="line.41"></a>
<FONT color="green">042</FONT>            DerbyImplementation.constructLikeClauses(patts));<a name="line.42"></a>
<FONT color="green">043</FONT>    <a name="line.43"></a>
<FONT color="green">044</FONT>        patts.set(0, "*\\foo\\*");<a name="line.44"></a>
<FONT color="green">045</FONT>        assertEquals("Test single pattern, backward slash", singleSlash, <a name="line.45"></a>
<FONT color="green">046</FONT>            DerbyImplementation.constructLikeClauses(patts));<a name="line.46"></a>
<FONT color="green">047</FONT>        <a name="line.47"></a>
<FONT color="green">048</FONT>        // Test escape of an SQL wildcard.<a name="line.48"></a>
<FONT color="green">049</FONT>        patts.set(0, "foo_bar");<a name="line.49"></a>
<FONT color="green">050</FONT>        assertEquals("Test single pattern, wildcard", " AND ((RESOURCE LIKE 'foo`_bar' ESCAPE '`') )",<a name="line.50"></a>
<FONT color="green">051</FONT>            DerbyImplementation.constructLikeClauses(patts));<a name="line.51"></a>
<FONT color="green">052</FONT>        <a name="line.52"></a>
<FONT color="green">053</FONT>        // Test multiple URIs, path separators, and escapes.<a name="line.53"></a>
<FONT color="green">054</FONT>        patts.set(0, "*/foo_bar/*");<a name="line.54"></a>
<FONT color="green">055</FONT>        patts.add("*\\Test*.java");<a name="line.55"></a>
<FONT color="green">056</FONT>        patts.add("baz.c");<a name="line.56"></a>
<FONT color="green">057</FONT>        <a name="line.57"></a>
<FONT color="green">058</FONT>        String results = <a name="line.58"></a>
<FONT color="green">059</FONT>          " AND ((RESOURCE LIKE '%/foo`_bar/%' ESCAPE '`') OR " + <a name="line.59"></a>
<FONT color="green">060</FONT>          "(RESOURCE LIKE '%\\foo`_bar\\%' ESCAPE '`') OR " + <a name="line.60"></a>
<FONT color="green">061</FONT>          "(RESOURCE LIKE '%/Test%.java' ESCAPE '`') OR " + <a name="line.61"></a>
<FONT color="green">062</FONT>          "(RESOURCE LIKE '%\\Test%.java' ESCAPE '`') OR " + <a name="line.62"></a>
<FONT color="green">063</FONT>          "(RESOURCE LIKE 'baz.c' ESCAPE '`') )";<a name="line.63"></a>
<FONT color="green">064</FONT>    <a name="line.64"></a>
<FONT color="green">065</FONT>        //System.out.println(DerbyImplementation.constructLikeClauses(patts));<a name="line.65"></a>
<FONT color="green">066</FONT>    <a name="line.66"></a>
<FONT color="green">067</FONT>        assertEquals("Test multiple URIs, path separators, escapes", results, <a name="line.67"></a>
<FONT color="green">068</FONT>            DerbyImplementation.constructLikeClauses(patts));<a name="line.68"></a>
<FONT color="green">069</FONT>      }<a name="line.69"></a>
<FONT color="green">070</FONT>    }<a name="line.70"></a>




























































</PRE>
</BODY>
</HTML>
